SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480169 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480169 [ RunTime:0.001776s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (16698,402343,413857,122982,609914,768315,642910,437823,359504,717950,467168,533453,767059,456229,26719,652748,408104,444027,154352,879550,95330,126048,557910,511473,643265,407816,896468,635269,308217,608156,849784,690549,804757,389448,197928,388737,581868,550896,601180,146295,1015509,274362,896041,669406,878061,818017,138818,921262,364186,575214,1013019,512540,559244,311949,955775,739956,154870,228702,733055,428019) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480169 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480169 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]