SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402209 LIMIT 1 [ RunTime:0.000283s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402209 [ RunTime:0.001862s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (569039,62099,963253,749021,116110,478507,859395,91004,772086,787078,585110,695307,252067,1036336,77120,844994,318056,726387,353286,1025073,990471,878300,1037828,698520,669522,613049,435037,30388,970322,509239,309880,769419,1030940,456258,5310,158979,145477,835044,885695,731510,140218,545372,886270,633655,600316,1047171,184187,466122,1035617,334787,894453,426692,386096,598310,431507,943117,221211,941254,800120,839332) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402209 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402209 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000468s ]