SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475068 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475068 [ RunTime:0.001683s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (275158,368117,58213,786006,122089,456186,493234,55073,143154,982892,722245,295027,690954,862519,634087,707217,258904,896057,100202,437976,29562,295071,706193,47859,1043625,173106,282395,91585,345018,353780,535910,715836,319549,104856,4805,657536,828345,233994,893492,160652,35593,223992,856229,255139,604461,1013117,999169,112684,292718,246166,986607,554756,334133,820084,59741,388422,275340,951423,377784,982288) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000931s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475068 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475068 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000436s ]