SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001805s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 598563 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 598563 [ RunTime:0.001409s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1010115,110292,614479,189738,227223,788325,257819,854371,516709,366968,475582,886330,94523,842048,627419,574943,533327,526239,480666,122527,734725,848954,1014765,643944,147969,802790,14412,548935,559226,200083,992258,463018,316104,64922,653626,696673,389563,1017162,289235,773464,732891,991803,167481,643055,284949,757044,312199,89949,525766,484021,68631,1031747,43951,520921,901285,782516,491840,256377,982761,131990) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000953s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 598563 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 598563 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000494s ]