SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427738 LIMIT 1 [ RunTime:0.000292s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427738 [ RunTime:0.001785s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (150112,111715,487230,315279,188861,266632,272214,359704,884945,193182,697900,127887,681180,1018233,490864,399142,443258,680445,221009,62079,66222,872103,177499,933841,159096,793485,385521,699891,291412,978338,599640,247356,507642,471170,295000,736948,77629,273519,407481,68728,687647,773706,5696,620253,58212,359990,825076,268079,628944,45264,312605,499393,288304,654526,344531,212968,250085,965657,1002719,295129) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000923s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427738 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427738 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]