SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 173648 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 173648 [ RunTime:0.001522s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1011413,1042659,825207,215843,744208,40148,138646,224541,434486,859783,231157,901899,113852,119130,697490,650722,220166,34702,298063,11239,889798,678791,897271,370007,111901,456222,743158,419902,1004891,469407,910830,540075,588564,571783,763648,862828,624223,93874,71395,52417,595197,89912,250596,42478,44980,586790,339589,50980,808818,771657,95325,502798,142584,284435,76663,664785,576833,779652,28994,1000570) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 173648 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000321s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 173648 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]