SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002571s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 576238 LIMIT 1 [ RunTime:0.000480s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 576238 [ RunTime:0.004628s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (44304,17924,1018175,834342,196501,398051,716673,609621,846307,844074,203871,196111,635404,939350,1036036,921291,791433,231701,935834,78387,778629,805136,745740,956977,212704,503200,574933,810926,733377,130700,862674,571853,1040711,883229,57827,647578,866364,288591,262513,878183,1015927,404846,961538,907868,734662,412651,284168,426311,1037820,508831,830124,425246,670380,242270,757988,964834,245293,990837,793542,441873) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 576238 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000528s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 576238 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002293s ]