SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 150 LIMIT 1 [ RunTime:0.000451s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 150 [ RunTime:0.001892s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (427445,996099,1044909,908683,315225,502845,808689,734938,440757,758070,291824,626780,757795,481042,605092,258293,491465,940541,6066,109699,327535,101265,405819,671058,993452,867926,208440,411717,180151,1028614,933025,845057,415507,616495,350317,100157,830803,221048,684147,493522,320867,588909,682950,531603,124174,936797,354887,23709,782779,200070,247248,34414,787512,826385,620207,878390,476627,764936,729888,811266) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001017s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 150 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 150 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000443s ]