SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427938 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427938 [ RunTime:0.001981s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (423806,942822,872292,571735,563472,487796,636828,779977,839261,536715,259950,1006443,337237,573209,405114,262911,593832,867544,581450,71185,312931,809792,463458,100935,110945,28922,277973,475144,472658,721774,754622,866395,1041254,1015979,257434,103525,167546,434909,821829,572424,577282,795241,877944,996055,647217,213563,168078,582394,660838,699222,606352,914309,435482,738317,464523,685637,409301,1033560,730521,511153) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427938 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000607s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427938 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]