SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409236 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409236 [ RunTime:0.001544s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (344533,583246,731851,937622,159341,501596,312379,251501,48067,1023230,605907,611250,639152,906429,1035189,179406,466765,885677,1024316,747293,652282,863774,1015071,468548,83621,299491,645493,393423,658256,895879,830037,350239,569003,949298,169328,163393,205710,357305,954660,212763,32507,757988,758307,224842,1030088,109610,120539,987065,865352,295653,920173,348659,219225,515084,176375,391825,179863,1014713,237067,426584) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409236 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409236 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]