SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001712s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023313 LIMIT 1 [ RunTime:0.003172s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023313 [ RunTime:0.002239s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (397448,354718,728488,520770,528741,930666,787771,138401,497999,245444,422275,80265,1032617,1028524,760501,784161,1004641,138925,272437,74096,819606,60755,280999,860861,100508,144680,412489,926686,189560,959856,672685,149589,787269,688987,604738,180699,111792,49068,858822,978302,244464,801752,740199,194293,1021486,938624,702782,292489,924933,619713,919550,1046948,970334,308937,438035,631383,940252,494797,293727,177592) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001765s ]