SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538341 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538341 [ RunTime:0.001710s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (307970,154288,322303,40418,398007,36106,284886,151190,46623,650975,69298,407306,349236,390897,509838,580727,619998,415438,859040,566106,361643,735560,751419,852943,276961,863171,865385,648377,1040101,18521,135445,340627,1041180,573804,248554,196022,430242,684981,84728,202601,176067,895628,181531,785686,1018941,515954,214300,409813,390707,702129,59146,424667,993556,1018119,397505,254726,641610,968141,924133,55230) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538341 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538341 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]