SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535544 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535544 [ RunTime:0.001714s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (510140,971186,638691,54276,178925,404031,900447,1033999,466748,209356,690870,440397,396189,497428,637220,468222,589998,913710,737587,558245,231956,321191,517534,75047,181758,963617,961352,163622,495220,842214,862398,662329,521317,171453,238560,89571,465402,940373,556321,775364,302945,439541,730686,831741,212352,861573,326193,515539,88948,267315,438648,215344,570151,391123,831339,137679,473426,200798,774989,490867) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535544 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535544 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001866s ]