SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001411s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412365 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412365 [ RunTime:0.004443s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (755716,569872,668118,294260,1045798,527470,312744,462646,267960,842092,869770,587420,931200,111382,485347,567174,381815,1002621,72204,430602,245437,189483,79471,1034966,267073,93200,448911,420061,202996,844327,771805,992193,245208,383694,860581,638246,625400,131333,488707,641161,991760,170459,719894,780550,114468,834412,771153,542357,758214,469884,269366,575136,93849,39519,960054,772616,58755,62340,17519,801608) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412365 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412365 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000999s ]