SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001822s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 314107 LIMIT 1 [ RunTime:0.001100s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 314107 [ RunTime:0.001796s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (497600,420636,384651,752293,623765,740936,511582,739940,376001,774020,215961,1026134,820595,412543,69192,595516,80850,436732,557531,6208,873713,355768,1040496,44102,410254,571347,364216,582851,791076,302078,700502,209890,655038,766049,340072,296710,225779,459559,870791,691683,157100,834481,414364,930493,104623,326515,897095,64579,115598,669563,983248,856025,639562,282748,1036958,241448,367902,478632,919180,838527) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 314107 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 314107 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001478s ]