SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502834 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502834 [ RunTime:0.002322s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (393766,538473,349833,784641,103661,394497,415696,681293,118156,117417,806067,749388,29092,911432,419873,513263,699088,236321,509300,436576,270808,504159,125542,277379,546458,858083,777054,803699,631358,208165,168090,326267,468611,446440,794579,416194,19032,1019805,410363,151461,390225,67067,330625,118295,555160,310442,604631,917521,217354,15628,969903,886213,69272,565205,384680,75240,498766,251797,509797,511496) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502834 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502834 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]