SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001404s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 563979 LIMIT 1 [ RunTime:0.000465s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 563979 [ RunTime:0.005358s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (589097,888808,165631,820237,292398,8648,858939,412748,284296,425958,467239,512089,736254,921561,871678,639867,1021536,1005657,330750,703670,613536,752549,614624,139965,235221,150090,588301,863836,423565,982270,482430,120241,709132,4038,787614,450279,685618,755774,395516,398138,686799,362516,157928,235399,439812,380351,406650,235681,1044030,508806,888906,325978,344250,799591,192603,1016732,187147,595706,818987,548501) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 563979 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 563979 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]