SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517101 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517101 [ RunTime:0.004805s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (189858,280446,332371,196253,867428,142141,377566,1023048,895591,315037,425643,611221,471808,428350,72519,87478,197178,966646,694770,863385,285015,460245,809418,126899,428638,764050,186479,195739,970598,801921,242321,205260,650795,693569,756835,619250,396167,543874,984454,46058,130041,856585,908682,976942,953858,473696,326339,880957,752056,571855,97352,367464,305309,302404,145046,46246,620194,203090,264893,954899) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002214s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001504s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002754s ]