SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 954080 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 954080 [ RunTime:0.001461s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (301958,908185,505031,473734,878289,365557,467481,745794,624935,59491,252757,258905,531887,315292,1021369,700268,293188,897438,174113,1035387,857220,848761,390810,864958,404941,670681,618895,584631,305702,943692,869022,994477,77027,1037201,95600,857610,257550,597538,753903,980301,396107,813019,608270,1001358,362414,68484,345285,884158,64335,48396,270479,1009371,697935,800110,634449,702301,829215,953047,312525,748757) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000958s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 954080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000498s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 954080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]