SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047838 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047838 [ RunTime:0.002031s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (25899,661746,465598,155587,348802,609675,129765,235260,454401,1041990,915830,396367,683389,435741,502088,106042,548807,435989,754659,147525,773461,376414,646776,350039,8981,976185,939322,85974,1026745,743637,192410,792240,478631,849268,904821,1004491,507255,933506,771291,523,43634,233814,912009,201059,1041048,767629,1003792,1041571,343336,909604,993396,758453,149880,662809,224653,247026,434694,867717,343263,519909) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047838 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047838 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000492s ]