SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418963 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418963 [ RunTime:0.002321s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (528467,503080,319345,436924,331386,745826,525359,236708,624254,800535,976741,149052,158987,872285,417119,488589,251110,468092,864045,296005,160947,563276,263459,815760,772242,386082,404308,997091,469010,434199,191466,828501,871560,484394,378640,452330,431991,25849,513739,534325,349139,456304,63836,874843,676785,893078,144254,1045929,884220,621244,649328,1005550,370591,307283,600951,796,989512,473884,936343,688267) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000964s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418963 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418963 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]