SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001308s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1007640 LIMIT 1 [ RunTime:0.000623s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1007640 [ RunTime:0.002683s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (382049,1012673,765275,39654,320142,365681,771100,434124,11132,181607,1000781,557494,691653,933132,637859,63924,105502,797122,462914,892744,251150,301641,765128,452175,1008335,785206,416454,66641,952208,33933,347917,358551,19605,143553,269733,598520,14880,494447,824045,89851,245185,552549,384469,199610,841242,663653,576864,250528,538631,47589,126895,321326,110056,210802,693824,870361,1030626,1000482,193578,980658) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1007640 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1007640 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000721s ]