SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531912 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531912 [ RunTime:0.002354s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (310600,424602,56302,245853,260903,271319,302395,272772,940877,508061,583134,280388,122052,458570,758795,846829,561475,492309,1019588,758704,148359,626272,397522,755620,14423,662212,207530,334645,295036,793548,345746,818509,140807,122522,993291,838816,897400,1033245,906499,147735,182296,11815,441252,757768,412923,270739,921014,210012,990061,842335,98115,1029223,804437,654244,86078,673298,402991,626553,340577,522754) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531912 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531912 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000430s ]