SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001489s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 189855 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 189855 [ RunTime:0.002296s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (404708,439857,214153,447359,473274,193186,163577,303763,866404,895153,506364,345568,299934,348357,219932,705032,362899,154753,625463,822653,630216,704090,601100,284055,777379,205628,803165,405055,204007,206696,961080,415509,397320,770508,165775,880764,302300,559641,594957,203413,568409,365885,41613,301889,18132,366543,994899,113261,160925,62506,722589,763736,299371,598315,800673,359453,753570,970450,982179,827388) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 189855 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 189855 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000453s ]