SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520984 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520984 [ RunTime:0.002532s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1000323,315923,396486,431308,977294,148258,980729,377877,697304,507430,624090,41957,1008985,256162,440327,715060,729789,1048815,1045387,314865,415309,455674,866693,981228,637642,571141,738509,998136,694752,161684,242392,263854,518739,268944,426150,305511,782465,738014,882346,973184,220779,152341,632083,930959,558190,429168,842887,442551,257539,49336,766752,115789,97139,45709,607860,467147,512054,778989,168685,581545) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520984 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520984 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]