SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 584601 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 584601 [ RunTime:0.002538s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (246552,25019,211868,809748,116854,120294,182031,76075,856412,86838,397121,27656,377575,662659,50893,6473,393234,731468,416893,830452,256855,487075,715550,125913,700250,361991,896215,599815,1037118,227399,28624,587777,437436,34494,439271,577072,79984,639966,626555,952654,1027420,492478,581446,479283,38647,54914,279358,830359,409089,732490,562812,346339,434020,401929,94232,81659,308095,324943,762812,72368) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 584601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 584601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000462s ]