SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 107048 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 107048 [ RunTime:0.001727s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (592593,397104,964061,710374,143602,1000552,919641,27867,641752,730775,240345,190467,46011,1004969,1042260,380991,126375,2739,937275,733736,474806,1017441,680134,627913,672114,382245,150996,1021855,335035,17039,81345,202022,1028740,1038668,648136,125921,697316,735844,238662,441986,588708,819731,296623,434954,280970,190125,559155,539762,792674,179657,412758,641532,1020174,955269,86721,463074,823240,315300,465134,910840) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000967s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 107048 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 107048 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]