SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438991 LIMIT 1 [ RunTime:0.000558s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438991 [ RunTime:0.004167s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (787702,10590,483561,180229,592430,129415,898604,1027604,720821,137613,477804,266255,554316,563940,782542,948945,448434,557955,880312,452513,945437,711005,266112,251207,632982,844448,130361,462744,864757,480000,175504,508351,257719,473569,294430,201483,992236,440542,150853,246703,929566,972573,457462,833505,306840,454556,1011177,680242,307736,151918,357528,757294,860967,347301,698817,113253,936960,533819,3621,441049) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438991 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438991 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000721s ]