SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001355s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 477226 LIMIT 1 [ RunTime:0.000934s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 477226 [ RunTime:0.002124s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (427417,443417,625390,356252,179279,199522,555711,606658,253760,798929,652572,39723,408712,8989,273910,953818,768028,509359,480084,285774,795451,385606,772270,782574,1004717,373164,32101,496093,822453,915136,896770,218990,532021,294601,394193,61191,324173,507381,36896,29620,367582,818070,572140,735566,189387,354301,359605,335753,195356,819099,594510,833351,844806,620256,253065,433405,325026,483489,630478,915) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 477226 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000592s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 477226 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001433s ]