SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502782 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502782 [ RunTime:0.001497s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (310109,216842,905630,240588,221733,816256,779706,665221,861504,418611,428880,322397,948898,292484,649707,238830,373626,50648,670916,526474,343390,25561,865890,965985,210167,363025,146050,710205,734687,378571,621177,113105,108833,633505,719806,118688,721040,1041170,38900,82676,557553,414447,509591,34202,875557,1029078,1018132,1027880,139100,962411,983959,611187,936866,810557,656230,990311,164811,631885,208270,120601) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502782 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502782 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]