SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018173 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018173 [ RunTime:0.001891s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (447671,918019,1003822,1042643,174395,316548,607997,787289,681919,307608,635655,44552,979282,431321,202292,899020,5643,40856,299409,495262,834360,18776,792881,79719,127923,996849,645118,542282,210705,208966,218013,1010806,814193,76111,835275,385962,262335,104154,445604,646243,444249,915965,1014553,932547,154053,137626,332137,990158,723675,1012631,394434,885289,433219,998081,210446,872256,750843,365496,992772,395729) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000933s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018173 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000317s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018173 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000410s ]