SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536243 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536243 [ RunTime:0.001974s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (684130,326878,835130,386012,654660,560438,70397,677713,368493,895532,1623,613750,262359,4067,289939,198918,308530,404831,524232,116040,398681,276598,437410,422647,425284,969709,152980,1004477,27040,59615,842795,192833,876862,923898,352235,320797,965796,1023755,85848,212176,117731,866847,76342,683221,400403,46508,675082,949333,50242,569887,782726,950870,829793,543134,869735,522632,824751,546238,229864,625328) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536243 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536243 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]