SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104035 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104035 [ RunTime:0.001833s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (539362,847360,900145,628505,938974,780067,259940,244960,179029,569715,201146,618808,125888,665718,642864,178728,659611,639688,800108,522695,246479,985207,371740,137620,433868,843107,276416,681434,1034008,208105,959860,765658,1035372,690643,232027,703560,142706,755361,217522,688032,764087,390021,371590,306143,76398,1023815,967431,537704,610916,322506,928137,15274,42304,825602,538544,449301,124773,155680,490920,571761) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104035 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104035 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]