SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 431748 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 431748 [ RunTime:0.001764s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (72240,360871,685462,898819,700628,307316,90155,527022,934695,19349,244260,143085,101571,206751,338796,396756,741417,814203,892071,641940,895737,354293,795842,1042284,119778,205505,928988,441789,349018,309992,407139,113022,738677,855749,159147,751609,425450,1021204,968419,68704,322202,865891,1042862,421112,677238,807414,444260,199029,230173,499712,167624,888084,236764,62390,372123,521227,105786,610601,761712,115197) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 431748 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000820s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 431748 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]