SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535210 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535210 [ RunTime:0.002083s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (418756,901043,662902,435528,439387,732441,499688,429649,922631,250734,653267,126021,772593,482853,97111,301173,898052,55593,1046688,98829,294798,925489,632330,330555,559989,486545,182929,554477,1048430,940465,1040805,60735,780739,665630,483038,751625,124408,367035,278017,665563,441945,22698,310491,480506,639707,661617,193454,502643,314866,422112,258793,574301,495453,148340,526548,872411,478349,542744,76427,212052) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000981s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]