SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502136 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502136 [ RunTime:0.001742s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (457777,655148,547952,46899,420750,489057,633133,834720,277234,495680,456045,775828,812420,299730,1034383,174959,291908,507890,480781,610931,757745,184067,1034,870440,622167,379212,384469,339591,212546,13199,422201,173145,441503,217020,657080,495194,462797,994857,848868,186801,13345,935173,109452,810101,953179,290307,960358,115057,1012166,729060,27078,975306,774032,442897,324170,108523,221740,1015700,904437,479539) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502136 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000457s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502136 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]