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` = 10488 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10488 [ RunTime:0.001780s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (484278,423887,258664,596704,634852,863243,14816,885668,98598,911504,907639,569888,184291,674753,578107,98810,68686,652370,318880,645119,307033,200884,210032,449051,801556,243642,555660,777672,1006401,904722,82134,567065,31895,522359,281245,357797,296479,465958,933616,618496,564275,486902,485826,287118,835827,926852,65724,857219,1036693,654277,916413,590765,898453,785801,685100,597544,876477,758180,411529,429831) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10488 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10488 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000849s ]