SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 204111 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 204111 [ RunTime:0.002573s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (88691,125979,1020028,200944,833906,135720,549451,334361,835149,832361,24096,827803,413755,443282,393495,338191,620028,678239,100128,410935,27774,377954,952182,845809,269800,373773,125851,168962,516461,792640,1026733,44152,327069,891289,647622,92897,280831,977588,66055,1022016,291483,889859,533263,664509,306917,1034332,1010279,396012,115126,864954,863950,410495,128268,947438,701552,9974,1018786,386736,76127,543821) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 204111 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 204111 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]