SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533642 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533642 [ RunTime:0.001445s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (881960,1038609,737077,916152,582868,272713,686501,719465,661432,1008575,215512,788143,354239,412241,26731,603733,557777,179445,80875,492923,105864,906324,400202,972269,198841,1040692,441688,231181,903748,913970,857272,884653,865311,232137,1000974,163364,485456,320133,664686,557575,769313,862346,1013020,558529,683125,256516,743498,499479,872072,244431,434585,148833,705707,767409,328698,53361,703387,754859,308782,162304) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533642 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533642 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]