SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001659s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 537976 LIMIT 1 [ RunTime:0.000638s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 537976 [ RunTime:0.002854s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (457363,156528,926865,2200,8650,951905,434059,670772,606517,252072,889524,286849,815609,986294,421785,943115,659659,318373,408160,629602,768216,684037,581637,377561,491963,34089,836890,1019165,517927,89441,560297,804030,379013,66515,784096,210566,942589,625732,149421,511808,661419,1018371,1000062,921805,958084,926484,473650,281987,745949,708685,270390,652664,63452,247692,443584,838915,8256,51160,325938,137460) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001662s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 537976 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001906s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 537976 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]