SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 476841 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 476841 [ RunTime:0.004537s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (548291,934507,411436,715521,465041,674584,670782,94069,779726,336028,433063,226015,245251,1036423,819399,683184,351675,664201,239801,749302,935284,389185,214301,190166,940816,328492,886927,928133,76532,293700,203702,949600,696605,388850,775022,8686,438605,441856,259961,178590,1047699,838606,537138,168073,426530,116576,27956,396722,1001373,353223,291395,115098,203122,422567,68289,117646,50152,215338,933057,354567) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002554s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 476841 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 476841 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000451s ]