SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 197093 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 197093 [ RunTime:0.001611s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (544089,842,871768,797472,962677,490446,251034,279785,539412,652493,1006635,737933,908145,315084,410972,1038156,639304,718789,366350,566866,641371,733103,462682,703313,391247,1016692,970308,815044,1003804,304830,394848,389302,448430,934046,751058,738954,878241,628929,598180,988393,369682,246654,872860,14017,876505,522594,156699,875838,1031235,625187,951859,130645,691655,1044492,430561,871237,29555,1022304,612538,319626) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000948s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 197093 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 197093 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]