SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002124s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101838 LIMIT 1 [ RunTime:0.000584s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101838 [ RunTime:0.001815s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (533340,313570,745938,59995,578787,532170,793620,410584,61618,654838,626401,129145,297133,322587,477794,477808,9079,79897,331979,405720,193070,152413,325241,644996,545319,701758,884720,1014110,814076,210335,548011,198097,889616,998311,266549,325240,552893,865977,593108,236588,1034476,406540,111249,1013309,127909,546403,485122,96627,796508,69204,735759,329964,97477,980927,835506,321589,464340,367269,957814,152703) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101838 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101838 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002336s ]