SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 495541 LIMIT 1 [ RunTime:0.000543s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 495541 [ RunTime:0.001664s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (476326,235161,258336,346446,835590,853418,147393,296455,593876,480786,905404,703316,982660,33101,269473,935668,794168,838670,212202,104077,631373,196880,452802,812255,868727,106324,197206,466692,695643,50690,144302,441533,577505,937399,313587,781084,1038244,399027,205345,475477,566665,614065,117961,73854,430944,492902,1016721,805428,901167,946931,650378,111579,685248,361880,604736,98841,571762,211816,3055,110286) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 495541 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 495541 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]