SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 563181 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 563181 [ RunTime:0.002025s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1034394,68855,351258,187737,435042,904374,491777,552868,788586,559183,412257,883255,120820,461355,777330,744263,784093,930527,146465,557483,154518,669156,12826,110007,192003,907574,959128,352107,988259,370885,772194,924245,564988,799200,440201,394810,432147,429495,918056,435736,441850,808528,1004498,105257,918713,484016,492370,593511,102973,293278,247925,714151,25846,595607,53374,762888,364240,508920,603684,623676) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001317s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 563181 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002530s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 563181 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]