SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017140 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017140 [ RunTime:0.003113s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (254328,188524,175308,452745,165620,565083,302441,692632,29202,178784,413104,24546,51244,381176,946605,986886,995365,725500,821279,103935,224487,628674,733169,711483,11188,739504,37633,145303,910483,2540,934699,756044,292704,548545,529472,311050,715435,576185,235115,421092,110737,281243,536788,903537,30013,960940,108873,585597,1005005,232769,427288,19765,536881,570332,343345,430509,631303,339943,561817,1047636) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017140 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017140 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]