SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480780 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480780 [ RunTime:0.002898s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1043733,271563,316473,642202,62288,246078,810811,340951,293288,289306,482621,608517,204481,944331,354684,796887,361148,120725,755484,390493,584791,1001378,469485,954609,842501,511303,264962,424959,401432,690474,821703,312780,101760,529580,1016737,876177,20864,23830,497820,150440,771073,263138,415084,739081,611560,671117,589854,741480,13343,523970,378701,968635,353896,225316,173242,99879,335779,71243,918600,957742) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480780 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480780 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]