SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102076 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102076 [ RunTime:0.001885s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (997033,832858,662451,609463,978022,122787,744759,835360,18418,998614,733782,562030,128474,403516,475978,859372,328425,39591,580574,768839,872300,76522,433211,790170,151641,878318,656601,57346,711872,93207,554211,8774,886707,590539,563870,110415,829520,368094,578466,200372,941566,376053,482150,397132,408767,55349,28306,534460,116756,119842,96446,793950,924126,816747,61372,782111,432122,470134,217275,543413) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102076 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000874s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102076 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]