SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538140 LIMIT 1 [ RunTime:0.001400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538140 [ RunTime:0.001455s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (201284,1038841,102789,298230,324119,419380,189055,1026121,157071,385747,267776,452665,512387,274289,86929,408030,511796,569336,996611,663391,118157,530180,273389,366253,450787,659755,401546,898531,410972,605804,342267,140620,308511,776345,19650,388631,25560,24606,96555,170807,61623,742066,37238,985610,765096,210822,673287,298160,915030,640261,247663,722663,72970,886719,381179,417177,985673,440828,773507,379781) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538140 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538140 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002847s ]