SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 349018 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 349018 [ RunTime:0.001592s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (16687,447345,715865,918226,746417,394905,114902,50328,19394,448688,16963,308485,257756,1023799,439383,467487,136953,945329,445174,842985,414275,866175,63779,208396,628203,699972,673988,958643,707532,697117,1011100,164864,184587,840193,383256,418093,976061,801828,774920,717066,656581,763863,338261,631313,441324,23540,476746,239055,7835,420357,225721,831602,1022821,293245,595841,285638,231811,52345,422319,977390) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 349018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 349018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]