SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104248 LIMIT 1 [ RunTime:0.000937s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104248 [ RunTime:0.001943s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (394701,57095,330207,345208,401342,426735,585654,1045191,392966,461120,447754,725405,44686,1002973,925694,417955,894713,105576,955093,790699,413893,528362,724060,126664,801691,806208,960873,912841,752744,807961,414648,399313,121788,273248,586355,210349,313099,330290,999923,908369,782020,409866,1038587,18496,765099,480227,827435,1025480,763955,804359,649987,539181,105635,1039564,617962,1042528,732405,453238,767440,487427) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.025294s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104248 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104248 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002308s ]