SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001754s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503763 LIMIT 1 [ RunTime:0.002003s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503763 [ RunTime:0.006272s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (460310,1001908,570963,877859,452075,696843,631991,326971,870883,980813,825391,551392,975992,250299,635185,481822,903744,552545,394003,926036,329722,383770,380567,697197,174865,89816,896790,841431,508896,304319,875753,9666,962382,325779,155861,589374,749088,665237,847787,775670,1036226,649411,758841,542004,644253,981035,353362,128306,278148,451362,77277,780501,427112,560138,217836,746428,10411,1037060,434478,283149) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001623s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503763 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503763 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000456s ]