SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 813813 LIMIT 1 [ RunTime:0.000449s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 813813 [ RunTime:0.001592s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (181861,1001640,541099,845186,448511,378682,2158,629218,543406,100830,82084,898773,572250,673160,415645,39717,106717,939153,677550,900182,268801,490764,337135,383571,821960,977440,535782,769397,330131,165713,929985,29964,67986,341007,878761,934593,770203,86916,795827,521545,361651,91306,706994,525695,566425,633214,547890,289956,933674,741192,125841,295393,868608,931265,433131,190884,920637,867121,683124,849783) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 813813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 813813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]