SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002006s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 6599 LIMIT 1 [ RunTime:0.000432s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 6599 [ RunTime:0.001883s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (44755,829631,247126,1024054,938127,648810,778118,174361,37317,875531,473603,536787,283915,339410,306076,880278,533572,623173,1021600,765555,490072,691308,582926,395577,135907,141665,380695,257985,825926,116104,1046785,100064,578239,1012138,286032,982671,502342,376459,823157,93200,550837,34466,243416,321706,391054,824075,260392,158470,261191,211176,137966,427885,249629,972998,231469,692673,875967,928316,474488,546871) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 6599 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 6599 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]