SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001311s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 188491 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 188491 [ RunTime:0.001768s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1010352,797086,598845,895124,574688,358586,575564,357323,155361,945689,631598,580416,261492,754557,708453,664702,202372,931332,419666,188987,833998,441860,413247,478562,1012589,640791,230336,910919,863635,819038,22095,478324,635502,794622,39469,7516,906867,926205,403570,287594,597355,570679,294505,827475,965030,197437,164436,1034810,119456,203988,801129,608555,744221,834461,420839,684498,370655,956341,490164,872921) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 188491 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 188491 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]