SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 477527 LIMIT 1 [ RunTime:0.000490s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 477527 [ RunTime:0.002561s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (658537,79359,195965,475864,1027253,364118,823161,9948,589693,279550,1022303,778708,853067,919103,328988,771269,70486,313371,176559,828815,57580,543121,974235,1031014,237060,576435,171686,951633,844828,660912,515246,802654,43588,290851,277353,278595,562167,520412,598674,269754,485507,289609,268677,90813,131723,827464,959416,416767,404295,5706,122027,545585,278260,827997,144152,348939,660211,15343,157492,979075) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002618s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 477527 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 477527 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001715s ]