SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101918 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101918 [ RunTime:0.002821s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (251214,807937,587873,723143,765678,610411,118225,176560,435607,848797,84965,946204,1008030,181453,956910,292929,386801,581514,873373,157321,654286,656517,102588,640292,608321,500871,203632,753661,730620,847766,286825,599243,563274,306770,387571,477615,926883,459159,529021,758022,875838,31714,806281,247167,307175,1040826,442162,378757,513807,255433,1027714,651012,766681,429267,319801,840828,741280,374505,375486,334490) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001805s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101918 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101918 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]