SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501902 LIMIT 1 [ RunTime:0.000457s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501902 [ RunTime:0.006854s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (483178,1022146,332234,166110,805620,851252,684066,2700,673397,649529,83169,526933,409072,380942,919666,267341,100061,387572,68411,787088,79489,694254,632997,221106,684720,750109,481557,590652,738737,736383,872773,584586,720514,366328,838454,294550,628969,522820,1001581,514749,111240,849050,584879,126,614439,1039782,1016025,85268,956540,934279,998469,348603,492552,206477,128675,176182,1032382,445575,393433,895450) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501902 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000475s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501902 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004531s ]