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` = 231218 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 231218 [ RunTime:0.001952s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (513900,207255,1043413,896041,160657,495513,204015,628638,528419,847309,124615,529813,483689,625306,786157,732141,660958,646027,525348,848506,62993,863290,107206,291930,190809,910236,8549,791972,376208,228650,333019,105969,366639,793128,143654,690240,265604,1015102,722476,295316,147234,186557,334522,608017,415397,673809,940648,951079,67138,53846,933610,336663,868863,577965,499429,221511,182820,892070,7194,867215) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.015709s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 231218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 231218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]