SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 42210 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 42210 [ RunTime:0.002779s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (631922,254817,663284,369206,824627,165357,692342,353137,121635,338738,654977,495718,109878,262033,324184,675395,190140,978669,944016,251794,98682,813938,53995,403097,720733,51418,172875,607532,397,610274,9437,875222,298774,279918,529130,431494,916895,237548,369912,555694,289435,305862,563481,706352,45058,1022700,234178,14417,955804,181982,118527,444811,865753,66398,141310,703487,473666,746465,895405,1019894) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 42210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 42210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]