SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001773s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 434169 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 434169 [ RunTime:0.001845s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (643022,655620,759326,310872,101218,1024017,231119,127754,297968,502385,87464,358570,99712,912568,244388,565993,302582,711962,548577,29790,190030,583807,735924,964074,910178,323776,790763,9877,565519,707513,784642,650625,592065,812314,1000859,483555,486041,506375,1015186,857426,787414,189901,376121,1002813,922122,998565,817919,320552,1000733,432900,1035061,960967,189160,540499,719370,866394,226851,777676,842866,522178) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 434169 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 434169 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]