SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419438 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419438 [ RunTime:0.001651s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (975955,1017411,583576,914736,971277,868869,608336,359712,569999,18482,4985,879399,717021,996101,180350,861647,448375,810035,777141,496500,960262,2250,325960,1016904,372389,977044,876736,255920,1002406,564045,210848,39840,890371,162655,721944,497686,229417,439567,243605,888206,625481,224699,348701,582636,183495,1046668,1008433,557753,158584,319698,831847,197857,686835,560373,142203,830351,579192,314637,1040653,529171) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]