SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424736 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424736 [ RunTime:0.001444s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1040190,494831,228841,401963,849987,464381,349634,58913,126718,562903,902342,996460,925984,434896,551160,768781,412260,593224,230081,634333,513321,602677,783730,595505,663784,979125,107049,520345,758748,1044277,404151,819644,140467,310946,1039968,588200,355318,198383,722039,758013,693286,541852,187585,364967,840116,443564,539733,606694,881773,544396,278439,323117,17912,161582,603567,894441,754978,669689,303144,447806) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002908s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424736 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424736 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002769s ]