SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003296s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 580403 LIMIT 1 [ RunTime:0.003910s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 580403 [ RunTime:0.002426s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (67037,801527,445961,57898,394260,375059,337705,358613,932414,413673,406052,908330,260087,863007,797111,284867,261971,731170,523240,352366,348257,881162,823542,17356,54904,873763,731255,438599,1017667,31585,264765,322185,816327,345004,13584,768633,186273,454184,619173,373323,620398,1014379,386895,799362,613729,564722,20840,635798,163739,108122,362445,498206,218396,721039,1001587,192896,603987,822982,675204,804036) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 580403 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 580403 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000432s ]