SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 646303 LIMIT 1 [ RunTime:0.001276s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 646303 [ RunTime:0.002052s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (40541,339824,31876,154182,282759,396863,440803,784194,746104,526752,962692,481650,350409,190680,505137,738209,604010,507791,585555,406480,340640,544447,469971,148776,306431,502434,98591,740537,975563,422067,927827,138060,824533,659794,155529,367279,930633,871444,499886,385366,19671,870952,229829,82925,150514,1036877,160600,762409,626396,504257,703770,91111,221752,1023486,251208,992623,118397,269392,357721,182567) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001006s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 646303 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 646303 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000466s ]